[dbo].[BAEImisOrdersSearch]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisOrdersSearch

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@USER_ID	varchar(10)	10
@LAST_NAME	varchar(50)	50
@COMPANY	varchar(50)	50

SQL Script

create procedure [dbo].[BAEImisOrdersSearch] @USER_ID as
varchar(10),
        @LAST_NAME AS varchar(50),
        @COMPANY AS varchar(50)
AS
    SELECT * FROM Orders
    WHERE ST_ID LIKE (@USER_ID + '%') AND (LAST_NAME LIKE (@LAST_NAME + '%') AND COMPANY LIKE (@COMPANY + '%'))
    ORDER BY ORDER_DATE DESC

GO

Uses

[dbo].[Orders]
dbo